package org.zh.svs.pro.sv;

import org.springframework.stereotype.Service;
import org.zh.client.jdbc.ZHOpenJdbcUtil;
import org.zh.client.tra_ds.Transaction;
import org.zh.client.tra_ds.ZHOpenGlobalTra;

import java.sql.SQLException;

@Service
public class CurriculumService {

    @Transaction
    @ZHOpenGlobalTra
    public int updateTID() throws SQLException {
        return ZHOpenJdbcUtil.executeUpdate("update curriculum set teacher_id = teacher_id - ? where curriculum_id = ?",3,155);
    }
}
